
































  
  


  

  
  	
  

  

	
	

	
	
	
	
	




  
















	
	
	
	
	
	
	
	
	
	
  
  


	


	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	




    
  






  
    
  




	
	
	
	
	



<!--NewPage-->
<HTML>

<!-- Mirrored from delerium:8503/cfcdoc/content.cfm?file=C%3A%5CInetpub%5Cwwwroot%5Ctransfer%2Droot%5Ctransfer%5Ccom%5Csql%5CQueryBuilder%2Ecfc by HTTrack Website Copier/3.x [XR&CO'2006], Sat, 07 Apr 2007 03:17:35 GMT -->
<!-- Added by HTTrack --><meta http-equiv="content-type" content="text/html;charset=UTF-8"><!-- /Added by HTTrack -->
<HEAD>

<!-- Generated by CFDoc on 07-Apr-2007 01:17 PM -->

<LINK REL ="stylesheet" TYPE="text/css" HREF="stylesheet.css" TITLE="Style">
</HEAD>
<BODY>


	



<HR>
<!-- ======== START OF CLASS DATA ======== -->

<div style="float:left;">

<a href="default.html" style="float: right;">Documentation home page</a>
</div>
<H2>
<span style="font-size: smaller">
<a href="components3650.html" target="components">transfer.com.sql</a>
</span>
<BR>
Component QueryBuilder</H2>


<PRE>
<B>transfer.com.sql.QueryBuilder</B>
</PRE>


<HR>
Builds a Query out of BO data


<HR>

<P>


<!-- ========== PROPERTY SUMMARY =========== -->

<A NAME="property_summary"><!-- --></A>






<!-- ========== METHOD SUMMARY =========== -->




<A NAME="method_summary"><!-- --></A>

<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">

<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=2><FONT SIZE="+2">
<B>Method Summary</B></FONT></TD>
</TR>











	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	





	



	<TR BGCOLOR="eeeeff" CLASS="TableRowColorConstructor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="content20f8.html" target="_self">QueryBuilder</a></CODE></TD>
	<TD><CODE><B><A HREF="#init()">init</A></B>(<a href="content7dd0.html">ObjectManager</a> objectManager,&nbsp;<a href="content41fe.html">TQLConverter</a> tQLConverter)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Constructor
	</TD>
	</TR>
	

	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_struct" target="_self">struct</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildColumnStruct()">buildColumnStruct</A></B>(<a href="content7052.html">Object</a> object,&nbsp;[<a href="nativetypes.html#detail_struct">struct</a> columnStruct="#StructNew()#"],&nbsp;[<a href="nativetypes.html#detail_array">array</a> visitedClasses="#arrayNew(1)#"],&nbsp;[<a href="nativetypes.html#detail_string">string</a> compositionName=""])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds an struct with a key on table, with an array inside of each column, with type and column
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildConditionSQL()">buildConditionSQL</A></B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="contentbd42.html">Condition</a> condition,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds the where statement for a condition
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_array" target="_self">array</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildDuplicateArray()">buildDuplicateArray</A></B>(<a href="nativetypes.html#detail_struct">struct</a> columnStruct)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;builds the array of values that have duplicate columns
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildInitialFromSQL()">buildInitialFromSQL</A></B>(<a href="content7052.html">Object</a> object)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds the initial from SQL
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildManyToManyFromSQL()">buildManyToManyFromSQL</A></B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="content7052.html">Object</a> composite,&nbsp;<a href="content2709.html">ManyToMany</a> manyToMany,&nbsp;<a href="nativetypes.html#detail_string">string</a> fromSQL,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds the from SQL from a many to many composition
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildManyToOneFromSQL()">buildManyToOneFromSQL</A></B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="content7052.html">Object</a> composite,&nbsp;<a href="contentb6e3.html">ManyToOne</a> manyToOne,&nbsp;<a href="nativetypes.html#detail_string">string</a> fromSQL,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds the from SQL for many to one composition
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildOneToManyFromSQL()">buildOneToManyFromSQL</A></B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="content7052.html">Object</a> composite,&nbsp;<a href="contentd95b.html">OneToMany</a> oneToMany,&nbsp;<a href="nativetypes.html#detail_string">string</a> fromSQL,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds the from SQL for a One to Many SQL
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildOrder()">buildOrder</A></B>(<a href="nativetypes.html#detail_any">any</a> orderBuffer,&nbsp;<a href="contente034.html">Collection</a> collection,&nbsp;<a href="content7052.html">Object</a> object)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds the ORDER BY part of the sql
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildSelect()">buildSelect</A></B>(<a href="nativetypes.html#detail_any">any</a> buffer,&nbsp;<a href="content7052.html">Object</a> object,&nbsp;<a href="content7052.html">Object</a> parentObject,&nbsp;<a href="nativetypes.html#detail_struct">struct</a> columnStruct,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds the column list part of the SELECT for a given object
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_any" target="_self">any</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildSQL()">buildSQL</A></B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="nativetypes.html#detail_struct">struct</a> columnStruct,&nbsp;<a href="nativetypes.html#detail_string">string</a> fromSQL,&nbsp;<a href="nativetypes.html#detail_string">string</a> whereSQL,&nbsp;[<a href="nativetypes.html#detail_string">string</a> parentCompositeName=""],&nbsp;[<a href="content7052.html">Object</a> parentObject="#arguments.object#"],&nbsp;[<a href="nativetypes.html#detail_string">string</a> parentParentClass=""],&nbsp;[<a href="nativetypes.html#detail_any">any</a> buffer="#createObject('Java', 'java.lang.StringBuffer')#"],&nbsp;[<a href="nativetypes.html#detail_array">array</a> visitedClasses="#arrayNew(1)#"],&nbsp;[<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex="1"],&nbsp;[<a href="nativetypes.html#detail_string">string</a> compositeName=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> isArray="false"],&nbsp;[<a href="nativetypes.html#detail_any">any</a> orderBuffer="#createObject('Java', 'java.lang.StringBuffer').init('ORDER BY transfer_orderIndex ASC')#"])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds the SQL via a stringBuffer
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#buildWhere()">buildWhere</A></B>(<a href="content7052.html">Object</a> object)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds a WHERE statement
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#cast()">cast</A></B>(<a href="nativetypes.html#detail_string">string</a> column,&nbsp;<a href="nativetypes.html#detail_string">string</a> type)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cast the value of this to another value
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_struct" target="_self">struct</a></CODE></TD>
	<TD><CODE><B><A HREF="#createColumnMeta()">createColumnMeta</A></B>(<a href="content7dd2.html">Property</a> property,&nbsp;[<a href="nativetypes.html#detail_string">string</a> column="#arguments.property.getColumn()#"])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds the Column meta data. Struct returned with column name (column), and type (type)
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#createTableName()">createTableName</A></B>(<a href="nativetypes.html#detail_string">string</a> table,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates a table name from the table and hte orderindex
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="content7dd0.html" target="_self">ObjectManager</a></CODE></TD>
	<TD><CODE><B><A HREF="#getObjectManager()">getObjectManager</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>public <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#getObjectSQL()">getObjectSQL</A></B>(<a href="content7052.html">Object</a> Object)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates the SQL for the Object BO
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="content41fe.html" target="_self">TQLConverter</a></CODE></TD>
	<TD><CODE><B><A HREF="#getTQLConverter()">getTQLConverter</A></B>()</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setObjectManager()">setObjectManager</A></B>(<a href="content7dd0.html">ObjectManager</a> ObjectManager)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_void" target="_self">void</a></CODE></TD>
	<TD><CODE><B><A HREF="#setTQLConverter()">setTQLConverter</A></B>(<a href="content41fe.html">TQLConverter</a> TQLConverter)</CODE>
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_any" target="_self">any</a></CODE></TD>
	<TD><CODE><B><A HREF="#throw()">throw</A></B>(<a href="nativetypes.html#detail_string">string</a> type,&nbsp;<a href="nativetypes.html#detail_string">string</a> message,&nbsp;[<a href="nativetypes.html#detail_string">string</a> detail=""])</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Throws an Exception
	
	
	</TD>
	</TR>
	
	<TR BGCOLOR="white" CLASS="TableRowColor">
	<TD ALIGN="right" VALIGN="top" WIDTH="1%">
	<CODE>private <a href="nativetypes.html#detail_string" target="_self">string</a></CODE></TD>
	<TD><CODE><B><A HREF="#writeNULL()">writeNULL</A></B>(<a href="nativetypes.html#detail_string">string</a> column,&nbsp;<a href="nativetypes.html#detail_string">string</a> type)</CODE>
	
		<BR>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Overwrite to implement database specific NULL string text.
	
	
	</TD>
	</TR>
	
</TABLE>



&nbsp;
<P>



<!-- ============ METHOD DETAIL ========== -->


<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Method Detail</B></FONT></TD>
</TR>
</TABLE>












<A NAME="buildColumnStruct()"><!-- --></A><H3>
buildColumnStruct</H3>

<PRE>
private <A HREF="nativetypes.html#detail_struct" title="">struct</A> <B>buildColumnStruct</B>(<a href="content7052.html">Object</a> object,&nbsp;[<a href="nativetypes.html#detail_struct">struct</a> columnStruct="#StructNew()#"],&nbsp;[<a href="nativetypes.html#detail_array">array</a> visitedClasses="#arrayNew(1)#"],&nbsp;[<a href="nativetypes.html#detail_string">string</a> compositionName=""])</PRE>
<DL>
  <DD>
  	
  	
		Builds an struct with a key on table, with an array inside of each column, with type and column
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The BO of the object to build the list to</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_struct">struct</a> columnStruct="#StructNew()#"]</code> - Struct of Arrays defining tables and their columns</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_array">array</a> visitedClasses="#arrayNew(1)#"]</code> - Array of class names that have been visited</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> compositionName=""]</code> - The name of the composition</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="buildConditionSQL()"><!-- --></A><H3>
buildConditionSQL</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>buildConditionSQL</B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="contentbd42.html">Condition</a> condition,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</PRE>
<DL>
  <DD>
  	
  	
		Builds the where statement for a condition
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The Object that is being created in the collection</DD>
			
			  <DD><code><a href="contentbd42.html">Condition</a> condition</code> - The condition</DD>
			
			  <DD><code><a href="nativetypes.html#detail_numeric">numeric</a> orderIndex</code> - The order index</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="buildDuplicateArray()"><!-- --></A><H3>
buildDuplicateArray</H3>

<PRE>
private <A HREF="nativetypes.html#detail_array" title="">array</A> <B>buildDuplicateArray</B>(<a href="nativetypes.html#detail_struct">struct</a> columnStruct)</PRE>
<DL>
  <DD>
  	
  	
		builds the array of values that have duplicate columns
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_struct">struct</a> columnStruct</code> - Struct of Arrays defining the columns</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="buildInitialFromSQL()"><!-- --></A><H3>
buildInitialFromSQL</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>buildInitialFromSQL</B>(<a href="content7052.html">Object</a> object)</PRE>
<DL>
  <DD>
  	
  	
		Builds the initial from SQL
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The BO of the object to build FROM from</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="buildManyToManyFromSQL()"><!-- --></A><H3>
buildManyToManyFromSQL</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>buildManyToManyFromSQL</B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="content7052.html">Object</a> composite,&nbsp;<a href="content2709.html">ManyToMany</a> manyToMany,&nbsp;<a href="nativetypes.html#detail_string">string</a> fromSQL,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</PRE>
<DL>
  <DD>
  	
  	
		Builds the from SQL from a many to many composition
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The original object</DD>
			
			  <DD><code><a href="content7052.html">Object</a> composite</code> - The composite object</DD>
			
			  <DD><code><a href="content2709.html">ManyToMany</a> manyToMany</code> - The many to many connector</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> fromSQL</code> - The from SQL already written</DD>
			
			  <DD><code><a href="nativetypes.html#detail_numeric">numeric</a> orderIndex</code> - The order index of this select</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="buildManyToOneFromSQL()"><!-- --></A><H3>
buildManyToOneFromSQL</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>buildManyToOneFromSQL</B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="content7052.html">Object</a> composite,&nbsp;<a href="contentb6e3.html">ManyToOne</a> manyToOne,&nbsp;<a href="nativetypes.html#detail_string">string</a> fromSQL,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</PRE>
<DL>
  <DD>
  	
  	
		Builds the from SQL for many to one composition
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The original object</DD>
			
			  <DD><code><a href="content7052.html">Object</a> composite</code> - The composite object</DD>
			
			  <DD><code><a href="contentb6e3.html">ManyToOne</a> manyToOne</code> - The many to many connector</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> fromSQL</code> - The from SQL already written</DD>
			
			  <DD><code><a href="nativetypes.html#detail_numeric">numeric</a> orderIndex</code> - The order index of this select</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="buildOneToManyFromSQL()"><!-- --></A><H3>
buildOneToManyFromSQL</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>buildOneToManyFromSQL</B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="content7052.html">Object</a> composite,&nbsp;<a href="contentd95b.html">OneToMany</a> oneToMany,&nbsp;<a href="nativetypes.html#detail_string">string</a> fromSQL,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</PRE>
<DL>
  <DD>
  	
  	
		Builds the from SQL for a One to Many SQL
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The original object</DD>
			
			  <DD><code><a href="content7052.html">Object</a> composite</code> - The composite object</DD>
			
			  <DD><code><a href="contentd95b.html">OneToMany</a> oneToMany</code> - The one to many connector</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> fromSQL</code> - The from SQL already written</DD>
			
			  <DD><code><a href="nativetypes.html#detail_numeric">numeric</a> orderIndex</code> - The order index of this select</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="buildOrder()"><!-- --></A><H3>
buildOrder</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>buildOrder</B>(<a href="nativetypes.html#detail_any">any</a> orderBuffer,&nbsp;<a href="contente034.html">Collection</a> collection,&nbsp;<a href="content7052.html">Object</a> object)</PRE>
<DL>
  <DD>
  	
  	
		Builds the ORDER BY part of the sql
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_any">any</a> orderBuffer</code> - The java.util.StringBuffer for order bys</DD>
			
			  <DD><code><a href="contente034.html">Collection</a> collection</code> - The collection that is being created</DD>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The Object that is being created in the collection</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="buildSelect()"><!-- --></A><H3>
buildSelect</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>buildSelect</B>(<a href="nativetypes.html#detail_any">any</a> buffer,&nbsp;<a href="content7052.html">Object</a> object,&nbsp;<a href="content7052.html">Object</a> parentObject,&nbsp;<a href="nativetypes.html#detail_struct">struct</a> columnStruct,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</PRE>
<DL>
  <DD>
  	
  	
		Builds the column list part of the SELECT for a given object
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_any">any</a> buffer</code> - java.lang.StringBuffer class for the sql</DD>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The BO of the object to build the list to</DD>
			
			  <DD><code><a href="content7052.html">Object</a> parentObject</code> - The parent object to set the item to</DD>
			
			  <DD><code><a href="nativetypes.html#detail_struct">struct</a> columnStruct</code> - Struct of Arrays defining the columns</DD>
			
			  <DD><code><a href="nativetypes.html#detail_numeric">numeric</a> orderIndex</code> - The order index of this select</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="buildSQL()"><!-- --></A><H3>
buildSQL</H3>

<PRE>
private <A HREF="nativetypes.html#detail_any" title="">any</A> <B>buildSQL</B>(<a href="content7052.html">Object</a> object,&nbsp;<a href="nativetypes.html#detail_struct">struct</a> columnStruct,&nbsp;<a href="nativetypes.html#detail_string">string</a> fromSQL,&nbsp;<a href="nativetypes.html#detail_string">string</a> whereSQL,&nbsp;[<a href="nativetypes.html#detail_string">string</a> parentCompositeName=""],&nbsp;[<a href="content7052.html">Object</a> parentObject="#arguments.object#"],&nbsp;[<a href="nativetypes.html#detail_string">string</a> parentParentClass=""],&nbsp;[<a href="nativetypes.html#detail_any">any</a> buffer="#createObject('Java', 'java.lang.StringBuffer')#"],&nbsp;[<a href="nativetypes.html#detail_array">array</a> visitedClasses="#arrayNew(1)#"],&nbsp;[<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex="1"],&nbsp;[<a href="nativetypes.html#detail_string">string</a> compositeName=""],&nbsp;[<a href="nativetypes.html#detail_boolean">boolean</a> isArray="false"],&nbsp;[<a href="nativetypes.html#detail_any">any</a> orderBuffer="#createObject('Java', 'java.lang.StringBuffer').init('ORDER BY transfer_orderIndex ASC')#"])</PRE>
<DL>
  <DD>
  	
  	
		Builds the SQL via a stringBuffer
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The BO of the object to build the list to</DD>
			
			  <DD><code><a href="nativetypes.html#detail_struct">struct</a> columnStruct</code> - Struct of Arrays that defines tables and columns</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> fromSQL</code> - String that contains the from statement</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> whereSQL</code> - The WHERE clause of the SQL</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> parentCompositeName=""]</code> - The paren't composite name</DD>
			
			  <DD><code>[<a href="content7052.html">Object</a> parentObject="#arguments.object#"]</code> - The parent object to set the item to</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> parentParentClass=""]</code> - parent class 2 levels up</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_any">any</a> buffer="#createObject('Java', 'java.lang.StringBuffer')#"]</code> - java.lang.StringBuffer class for the sql</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_array">array</a> visitedClasses="#arrayNew(1)#"]</code> - Array of class names that have been visited</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex="1"]</code> - The order index of this select</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> compositeName=""]</code> - The name of the composite structure</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_boolean">boolean</a> isArray="false"]</code> - is this memento part of an array?</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_any">any</a> orderBuffer="#createObject('Java', 'java.lang.StringBuffer').init('ORDER BY transfer_orderIndex ASC')#"]</code> - java.land.StringBuffer that tracks order by statement</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="buildWhere()"><!-- --></A><H3>
buildWhere</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>buildWhere</B>(<a href="content7052.html">Object</a> object)</PRE>
<DL>
  <DD>
  	
  	
		Builds a WHERE statement
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> object</code> - The BO of the object to build the list to</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="cast()"><!-- --></A><H3>
cast</H3>

<PRE>
public <A HREF="nativetypes.html#detail_string" title="">string</A> <B>cast</B>(<a href="nativetypes.html#detail_string">string</a> column,&nbsp;<a href="nativetypes.html#detail_string">string</a> type)</PRE>
<DL>
  <DD>
  	
  	
		Cast the value of this to another value
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> column</code> - The column to write the 'NULL' for</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> type</code> - Type to cast it to</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="createColumnMeta()"><!-- --></A><H3>
createColumnMeta</H3>

<PRE>
private <A HREF="nativetypes.html#detail_struct" title="">struct</A> <B>createColumnMeta</B>(<a href="content7dd2.html">Property</a> property,&nbsp;[<a href="nativetypes.html#detail_string">string</a> column="#arguments.property.getColumn()#"])</PRE>
<DL>
  <DD>
  	
  	
		Builds the Column meta data. Struct returned with column name (column), and type (type)
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7dd2.html">Property</a> property</code> - The property to get the type from</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> column="#arguments.property.getColumn()#"]</code> - The column to set</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="createTableName()"><!-- --></A><H3>
createTableName</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>createTableName</B>(<a href="nativetypes.html#detail_string">string</a> table,&nbsp;<a href="nativetypes.html#detail_numeric">numeric</a> orderIndex)</PRE>
<DL>
  <DD>
  	
  	
		Creates a table name from the table and hte orderindex
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> table</code> - The name of the table</DD>
			
			  <DD><code><a href="nativetypes.html#detail_numeric">numeric</a> orderIndex</code> - The order Index</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getObjectManager()"><!-- --></A><H3>
getObjectManager</H3>

<PRE>
private <A HREF="content7dd0.html" title="">transfer.com.object.ObjectManager</A> <B>getObjectManager</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getObjectSQL()"><!-- --></A><H3>
getObjectSQL</H3>

<PRE>
public <A HREF="nativetypes.html#detail_string" title="">string</A> <B>getObjectSQL</B>(<a href="content7052.html">Object</a> Object)</PRE>
<DL>
  <DD>
  	
  	
		Creates the SQL for the Object BO
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7052.html">Object</a> Object</code> - The Object BO</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="getTQLConverter()"><!-- --></A><H3>
getTQLConverter</H3>

<PRE>
private <A HREF="content41fe.html" title="">transfer.com.sql.TQLConverter</A> <B>getTQLConverter</B>()</PRE>
<DL>
  <DD>
  	
  	
	
	
    
  </DD>
</DL>
<HR>




<A NAME="init()"><!-- --></A><H3>
init</H3>

<PRE>
public <A HREF="content20f8.html" title="">QueryBuilder</A> <B>init</B>(<a href="content7dd0.html">ObjectManager</a> objectManager,&nbsp;<a href="content41fe.html">TQLConverter</a> tQLConverter)</PRE>
<DL>
  <DD>
  	
  	
		Constructor
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7dd0.html">ObjectManager</a> objectManager</code> - The object manager to query</DD>
			
			  <DD><code><a href="content41fe.html">TQLConverter</a> tQLConverter</code> - Converter for {property} statements</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setObjectManager()"><!-- --></A><H3>
setObjectManager</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setObjectManager</B>(<a href="content7dd0.html">ObjectManager</a> ObjectManager)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content7dd0.html">ObjectManager</a> ObjectManager</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="setTQLConverter()"><!-- --></A><H3>
setTQLConverter</H3>

<PRE>
private <A HREF="nativetypes.html#detail_void" title="">void</A> <B>setTQLConverter</B>(<a href="content41fe.html">TQLConverter</a> TQLConverter)</PRE>
<DL>
  <DD>
  	
  	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="content41fe.html">TQLConverter</a> TQLConverter</code></DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="throw()"><!-- --></A><H3>
throw</H3>

<PRE>
private <A HREF="nativetypes.html#detail_any" title="">any</A> <B>throw</B>(<a href="nativetypes.html#detail_string">string</a> type,&nbsp;<a href="nativetypes.html#detail_string">string</a> message,&nbsp;[<a href="nativetypes.html#detail_string">string</a> detail=""])</PRE>
<DL>
  <DD>
  	
  	
		Throws an Exception
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> type</code> - The type of exception</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> message</code> - The message to accompany the exception</DD>
			
			  <DD><code>[<a href="nativetypes.html#detail_string">string</a> detail=""]</code> - The detail message for the exception</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>




<A NAME="writeNULL()"><!-- --></A><H3>
writeNULL</H3>

<PRE>
private <A HREF="nativetypes.html#detail_string" title="">string</A> <B>writeNULL</B>(<a href="nativetypes.html#detail_string">string</a> column,&nbsp;<a href="nativetypes.html#detail_string">string</a> type)</PRE>
<DL>
  <DD>
  	
  	
		Overwrite to implement database specific NULL string text.
	    <P>
	
	
		<DL>
		  <DT><B>Parameters:</B></DT>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> column</code> - The column to write the 'NULL' for</DD>
			
			  <DD><code><a href="nativetypes.html#detail_string">string</a> type</code> - The type to write the 'NULL' for</DD>
			
		</DL>
	
	
    
  </DD>
</DL>
<HR>







</BODY>

<!-- Mirrored from delerium:8503/cfcdoc/content.cfm?file=C%3A%5CInetpub%5Cwwwroot%5Ctransfer%2Droot%5Ctransfer%5Ccom%5Csql%5CQueryBuilder%2Ecfc by HTTrack Website Copier/3.x [XR&CO'2006], Sat, 07 Apr 2007 03:17:35 GMT -->
<!-- Added by HTTrack --><meta http-equiv="content-type" content="text/html;charset=UTF-8"><!-- /Added by HTTrack -->
</HTML>